City of Chattanooga Data Inventory Spreadsheet

City of Chattanooga Data Inventory Spreadsheet - Current


1	Step 1	Step 2						Step 3
2	Dataset Title	Division	Data Steward’s Email Address	Contents	System of Record	Contains Sensitive Data	Sensitive Data Comments	Data Quality	Data Value	Data Accessibility	Internal Priority Score	Workflow Status	Workflow Status Comment	Published Link
3	Human-readable name of the asset. Should be in plain English and include sufficient detail to facilitate search and discovery. Avoid acronyms.	Division where the data is maintained. If more than one department or division is responsible, list the primary owner of the dataset.	Data Steward's email address. Who manages the data and / or is responsible for granting permission to access the data? Who understands what the dataset includes and can answer questions about it?	What the dataset describes. Provide a longer description of the data that can be readily understood by non-technical users.	What is the original system/application/file that houses it? Please provide additional comments as necessary.	Does the dataset contain sensitive data, such as personal phone numbers, Social Security Numbers, etc.?	What could be done to make the data shareable?	What is the quality of the dataset?	How valuable is the dataset to the city internally? External value will be gathered by engaging the public.	How easy is it to access and publish the data on the open data portal?	Sum of the data quality, data value and data accessibility scores.	Where is the data in the open data workflow?	This the place to put any comments regarding the current status of the dataset.	This is the link to the published dataset on the open data portal. Just because the link is listed does not mean that it is available to the public because it is being reviewed through the open data workflow.
4	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES	VALUES
5	user defined	user defined	user defined	user defined	user defined	Yes	user defined	10	10	10	automatic sum	1 - identify datasets
6						No		5	5	5		2 - provide details
7								0	0	0		3 - internally prioritize
8	Data Inventory Steps											4 - externally prioritize
9	Step 1	Identify Datasets										5 - scheduled
10	Step 2	Provide Details										6 - exploration
11	Step 3	Prioritize Internally										7 - extraction
12	Step 4	Prioritize Externally										8 - transformation
13	Step 5	Schedule Date for Release										9 - loading
14												10 - internal review
15	For more details please refer to the city's Data Inventory Guide											11 - legal review
16												12 - publication
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37	Department	Step 1: Datasets Inventoried
38	City Attorney's Office	1
39	CARTA	6
40	CDOT	28
41	Courts	6
42	ECD	12
43	Finance	16
44	Fire	24
45	General Services	1
46	Human Resources	9
47	Library	11
48	Mayor	4
49	Office of Performance Management	2
50	Office of Multicultural Affairs	0
51	Police	15
52	Public Works	97
53	Information Technology	3
54	Purchasing	9
55	RPA	32
56	YFD	7
57	Total	283	239


1	Dataset Title	Department	Division	Data Steward’s Email Address	Contents	System of Record	Contains Sensitive Data	Sensitive Data Comments	Data Quality	Data Value	Data Accessiblity	Internal Priority Score	Workflow Status	Workflow Status Comment	Published Link

2	Freedom of Information Act (FOIA) requests	City Attorney's Office		dpatton@chattanooga.gov	This dataset contains the list of the freedom of information requests processed by the City of Chattanooga.	FOIA View	Yes		10	5	0	15	1 - identify datasets	Currently no systematic way to download data from FOIAView
3												0
4												0
5												0
6												0
7												0
8												0
9												0
10												0
11												0
12												0
13												0
14												0
15												0
16												0
17												0
18												0
19												0
20												0
21												0
22												0
23												0
24												0
25												0
26												0
27												0
28												0
29												0
30												0
31												0
32												0
33												0
34												0
35												0
36												0
37												0
38												0
39												0


1	Dataset Title	Department	Division	Data Steward’s Email Address	Contents	System of Record	Contains Sensitive Data	Sensitive Data Comments	Data Quality	Data Value	Data Accessiblity	Internal Priority Score	Workflow Status

2	General Transit Feed Specification (GTFS) for the route structure, stop locations and schedule of operation.	CARTA	Administration/IT	anniepowell@gocarta.org	GTFS files which include bus stop listing, schedule information and shape of routes	www.gocarta.org/#developers	No		10			10	1 - identify datasets
3	Automated People Counters (APC) data for each line for each bus showing where people are getting on and off the bus.	CARTA	Administration/IT	anniepowell@gocarta.org	report of boardings and alightings by route and stop	pdf report	No		5			5	1 - identify datasets
4	Monthly Ridership by Route	CARTA	Administration	anniepowell@gocarta.org	monthly ridership by route	excel	No		10			10	1 - identify datasets
5	Static Bus Schedules	CARTA	Administration/IT	anniepowell@gocarta.org	published bus schedules	http://www.gocarta.org/#routes	No		10			10	8 - transformation
6	Real Time bus location	CARTA	Administration/IT	anniepowell@gocarta.org	location of buses in real time	http://bustracker.gocarta.org/bustime/home.jsp	No		10			10	1 - identify datasets
7	FY Funding Allocation Percentage	CARTA	Administration	anniepowell@gocarta.org	graph of CARTA's annual funding allocation as a percentage	pdf	No		10			10	1 - identify datasets
8									10			10	1 - identify datasets
9												0
10												0
11												0
12												0
13												0
14												0
15												0
16												0
17												0
18												0
19												0
20												0
21												0
22												0
23												0
24												0
25												0
26												0
27												0
28												0
29												0
30												0
31												0
32												0
33												0
34												0
35												0
36												0
37												0
38												0
39												0


1	Dataset Title	Department	Division	Data Steward’s Email Address	Contents	System of Record	Contains Sensitive Data	Sensitive Data Comments	Data Quality	Data Value	Data Accessiblity	Internal Priority Score	Workflow Status	Workflow Status Comment	Published Link

2	Court Docket	CIty Courts	Court	reswafford@chattanooga.gov	There are generally 5 or 6 court dockets daily except for Friday when there are 3. The docket contains the citation number, the name of the defendant, and the violation. It is arranged alphabetically by defendant name.	Incode	Yes		10	10	10	30	1 - identify datasets
3	Citations	CIty Courts	Court	reswafford@chattanooga.gov	Citations are received from the Police Services Center and entered into the Incode system. A citation contains the violations, the defendant's personal information, vehicle information and location of incident.	Incode	Yes	Citations contain social security numbers and driver license numbers of defendant.	10	10	5	25	12 - publication	Data on the portal but needs to be automated to be updated lately	https://data.chattlibrary.org/Public-Safety/Traffic-Citations-By-Location-2012-To-2014/wnd5-ss2z
4	Collections	CIty Courts	Court	reswafford@chattanooga.gov	Fines/fees are paid at the City Court Clerk's office, online at www.chattanooga.gov/pay fine, or by U.S. mail.	Incode	No		10	5	5	20	1 - identify datasets
5	Judgments	CIty Courts	Court	reswafford@chattanooga.gov	Dispositions for cases are entered into the Incode system and on the final docket.	Incode	No		10	10	10	30	1 - identify datasets
6	Phone Calls	CIty Courts	Court	reswafford@chattanooga.gov	Court staff answers and responds to numerous phone calls daily. Staff also take calls from the bench while court is in session when documentation is needed.	TASKE	No		10	5	5	20	1 - identify datasets
7	Customer Service	CIty Courts	Court	reswafford@chattanooga.gov	Two cashiers plus a backup help customers who walk into the office.	Survey	No		5	5	5	15	1 - identify datasets
8												0
9												0
10												0
11												0
12												0
13												0
14												0
15												0
16												0
17												0
18												0
19												0
20												0
21												0
22												0
23												0
24												0
25												0
26												0
27												0
28												0
29												0
30												0
31												0
32												0
33												0
34												0
35												0
36												0
37												0
38												0
39												0


1	Dataset Title	Department	Division	Data Steward’s Email Address	Contents	System of Record	Contains Sensitive Data	Sensitive Data Comments	Data Quality	Data Value	Data Accessibility	Internal Priority Score	Workflow Status	Workflow Status Comment	Published Link

2	Lane miles treated	CDOT	CDOT - DE	etate@chattanooga.gov	Street miles index	MicroPaver	No		10	10	5	25	3 - internally prioritize
3	Paving Condition Index	CDOT	CDOT - DE	etate@chattanooga.gov	Street condition index	MicroPaver	No		10	5	5	20	3 - internally prioritize	Data map does not match redistricted Districts. MicroPaver has not been updated; the update is manual.
4	Sidewalk Connectivity Potential	CDOT	CDOT - DE		Pedestrian Improvement Plan	GIS	No		5	10	10	25	1 - identify datasets		http://www.chattanooga.gov/bicycle-implementation-plan/61-transportation/1542-bip
5	Temporary use of right of way applications	CDOT	CDOT - DE	kdoyle@chattanooga.gov	City temp use agreements	Word	Yes	name, address	10	5	5	20		CDOT processes the application and presents to Council for action. DPW records the decision in the GIS layer; not CDOT.
6	Paving Miles	CDOT	CDOT - DE	etate@chattanooga.gov	City street miles	Excel	No		10	10	5	25	1 - identify datasets
7	Number of feet of street lines painted	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	running total	a number	No		5	5	0	10	1 - identify datasets
8	Bike Chattanooga trip data	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	monthly stats on usage	Excel	No		10	10	10	30	12 - publication		https://data.chattlibrary.org/Transportation/Bike-Chattanooga-Trip-Data/8yba-nwv8
9	Bike Chattanooga station locations	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	list of sites	map	No		10	10	10	30	12 - publication	Automation not yet setup for this dataset	https://data.chattlibrary.org/Transportation/Bike-Chattanooga-Stations/49pq-4t5w
10	Bike Chattanooga real time system usage	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	real time dock/bike feed	web feed	No		10	5	10	25	12 - publication		https://data.chattlibrary.org/Transportation/Bike-Chattanooga-Real-Time-Station-Feed/54w5-89mf
11	Sign inventory and replacement status	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	location and condition of traffic signs	3M Asset Management	No		10	10	5	25	1 - identify datasets
12	Speed hump locations	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	map layer of speed humps	GIS	No		10	10	10	30	1 - identify datasets
13	Bicycle facilities	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	map layer of bike lanes and routes	GIS	No		10	10	5	25	1 - identify datasets
14	Traffic speeds and volume counts	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	speed and volume studies	Highway Data Management software	No		10	10	5	25	1 - identify datasets
15	Crash Reduction rate of 50% at targeted intersections	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	list of before and after studies	Excel	No		5	10	10	25	1 - identify datasets
16	Prevailing speed reduction at targeted corridors (NTMP)	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	list of before and after studies	Excel	No		10	10	10	30	1 - identify datasets
17	Complete 75% of Work Orders within 20 Days	CDOT	CDOT - TE	bgtaylor@chattanooga.gov	Traffic Operation's rate of completing work orders within 20 days	Excel	No		10	10	10	30	1 - identify datasets
18	Roundabout and Traffic Circle locations	CDOT	CDOT - TE	vanwinkle@chattanooga.gov	map layer of roundabouts and traffic circles	GIS	No		10	10	10	30	1 - identify datasets
19	ROW Abandonment applications	CDOT	CDOT - DE	bsutton@chattanooga.gov	City abandonment applications	Word	Yes	names, address	10	5	5	20	1 - identify datasets	CDOT reviews prior to PC recommendation; CDOT presents to Council for action. The recordation of ROW Abandonment occurs in DPW after the Council action.
20	Special Event Permits	CDOT	CDOT - TO	jsusman@chattanooga.gov	includes all events applied for that require street closures starting back in 2014	Excel	No		10	10	10	30	1 - identify datasets
21	Traffic Signal Timing	CDOT	CDOT - SC	kcomstock@chattanooga.gov	timing parameters for signalized intersections	TACTICs produces a report in Crystal reports and adobe.	No		5	5	10	20	2 - provide details	Working on New TACTIC Solution. I'll have new data set information on Friday 8/31
22	Average Speed and occupancy	CDOT	CDOT - SC	kcomstock@chattanooga.gov	Average Speed and occupancy on various roadways throughout the City	SNAP Server	No		10	10	5	25	1 - identify datasets
23	Vehicle Turning Movement Counts at (Gridsmart locations)	CDOT	CDOT - SC	kcomstock@chattanooga.gov	Historical turning movement counts (Counts by lane at a signalized intersection)	Gridsmart API	No		5	10	10	25	2 - provide details	Batch data
24	Vehicle Classification Data (Gridmart locations)	CDOT	CDOT - SC	kcomstock@chattanooga.gov	Historical Vehicle Classification data (Size of vehicle and percentage of that type vehicle at a signalized intersection)	Gridsmart API	No		5	10	10	25	2 - provide details	Batch data
25	Video feed from Gridsmart Fisheye Camera	CDOT	CDOT -SC	kcomstock@chattanooga.gov	Raw video feed/ Need processing for use in other areas	Need AXIS or other video management solution								Much work needed in field and headend.
26	Traffic Signal Inventory (GIS Mapping)	CDOT	CDOT - SC	kcomstock@chattanooga.gov	GIS Data on signalized intersections	GIS	No		5	10	10	25	12 - publication	Current GIS SHP file available. Data needs to be updated.
27	Photo enforcement fixed camera locations	CDOT	CDOT - SC	kdoyle@chattanooga.gov	list of camera sites	Excel	No		10	10	10	30	1 - identify datasets
28	Photo enforcement statistics	CDOT	CDOT - SC	kdoyle@chattanooga.gov	citation history	Excel	No		10	5	10	25	1 - identify datasets
29	Traffic Signal Preventative Maintenance Spreadsheet	CDOT	CDOT - SC	kdoyle@chattanooga.gov	Record of Preventative Maintenance Records	Excel and PDF	No		5	5	10	20
30												0
31												0
32												0
33												0
34												0
35												0
36												0
37												0
38												0
39												0